﻿--获得一条政策发布(多单位可见)
CREATE proc [dbo].[proc_Policy_GetItem_s]
(
	@NId uniqueidentifier
)
as
	select 
		Id,NId,Fid,Title,Content,UpName,IsAll,IsDing,IsEnd,CreateTime,UpTime,EndTime,CompanyId,CompanyIdList,
		Isnull((select title from Policy_category where id=fid),'未知') as category
  from Policy where NId=@NId